Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 75630 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 2204 |
| Duplicate rows (%) | 2.9% |
| Total size in memory | 7.5 MiB |
| Average record size in memory | 104.0 B |
Variable types
| NUM | 10 |
|---|---|
| CAT | 3 |
| Dataset has 2204 (2.9%) duplicate rows | Duplicates |
Date has a high cardinality: 1096 distinct values | High cardinality |
Net_Cost is highly correlated with Basic_Cost and 5 other fields | High correlation |
Basic_Cost is highly correlated with Net_Cost and 5 other fields | High correlation |
Basic_Selling_Price is highly correlated with Basic_Cost and 5 other fields | High correlation |
Selling_Price is highly correlated with Basic_Cost and 5 other fields | High correlation |
Tax is highly correlated with Basic_Cost and 5 other fields | High correlation |
Cash _Received is highly correlated with Basic_Cost and 5 other fields | High correlation |
Profit is highly correlated with Basic_Cost and 5 other fields | High correlation |
Discount has 36306 (48.0%) zeros | Zeros |
Reproduction
| Analysis started | 2022-04-03 00:04:36.277445 |
|---|---|
| Analysis finished | 2022-04-03 00:05:37.705974 |
| Duration | 1 minute and 1.43 second |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
Item
Categorical
| Distinct | 19 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 590.9 KiB |
| Mid Night Deal | |
|---|---|
| Zinger Combo | |
| Bucket of Fries | |
| Hot Wings | |
| Xtreme Box | |
| Other values (14) |
| Value | Count | Frequency (%) | |
| Mid Night Deal | 8325 | 11.0% | |
| Zinger Combo | 8325 | 11.0% | |
| Bucket of Fries | 6815 | 9.0% | |
| Hot Wings | 5311 | 7.0% | |
| Xtreme Box | 5290 | 7.0% | |
| Chicky Meal | 5280 | 7.0% | |
| Nuggests | 4537 | 6.0% | |
| chicken Piece | 3778 | 5.0% | |
| Arabian Rice | 3776 | 5.0% | |
| Pizza Twister | 3043 | 4.0% | |
| Other values (9) | 21150 | 28.0% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 18 |
|---|---|
| Median length | 12 |
| Mean length | 11.92977654 |
| Min length | 7 |
| Distinct | 1096 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 590.9 KiB |
| 20-Feb-12 | 135 |
|---|---|
| 20-Feb-11 | 135 |
| 20-Feb-13 | 135 |
| 18-Feb-11 | 104 |
| 18-Feb-13 | 104 |
| Other values (1091) |
| Value | Count | Frequency (%) | |
| 20-Feb-12 | 135 | 0.2% | |
| 20-Feb-11 | 135 | 0.2% | |
| 20-Feb-13 | 135 | 0.2% | |
| 18-Feb-11 | 104 | 0.1% | |
| 18-Feb-13 | 104 | 0.1% | |
| 18-Feb-12 | 104 | 0.1% | |
| 23-Feb-12 | 100 | 0.1% | |
| 23-Feb-11 | 100 | 0.1% | |
| 23-Feb-13 | 100 | 0.1% | |
| 31-Dec-11 | 99 | 0.1% | |
| Other values (1086) | 74514 | 98.5% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Quantity
Real number (ℝ≥0)
| Distinct | 28 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.62968399 |
|---|---|
| Minimum | 1 |
| Maximum | 45 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 590.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 6 |
| median | 11 |
| Q3 | 15 |
| 95-th percentile | 19 |
| Maximum | 45 |
| Range | 44 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 5.559944001 |
|---|---|
| Coefficient of variation (CV) | 0.523058259 |
| Kurtosis | -1.0972715 |
| Mean | 10.62968399 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | -0.09990373168 |
| Sum | 803923 |
| Variance | 30.91297729 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=28)
| Value | Count | Frequency (%) | |
| 16 | 6319 | 8.4% | |
| 12 | 5664 | 7.5% | |
| 6 | 5294 | 7.0% | |
| 13 | 4889 | 6.5% | |
| 15 | 4136 | 5.5% | |
| 11 | 4124 | 5.5% | |
| 2 | 4095 | 5.4% | |
| 9 | 3856 | 5.1% | |
| 7 | 3785 | 5.0% | |
| 18 | 3729 | 4.9% | |
| Other values (18) | 29739 | 39.3% |
| Value | Count | Frequency (%) | |
| 1 | 3283 | 4.3% | |
| 2 | 4095 | 5.4% | |
| 3 | 3366 | 4.5% | |
| 4 | 3431 | 4.5% | |
| 5 | 2348 | 3.1% |
| Value | Count | Frequency (%) | |
| 45 | 2 | < 0.1% | |
| 30 | 1 | < 0.1% | |
| 26 | 1 | < 0.1% | |
| 25 | 5 | < 0.1% | |
| 24 | 4 | < 0.1% |
Unit_Cost
Real number (ℝ≥0)
| Distinct | 38 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 437.9152453 |
|---|---|
| Minimum | 0 |
| Maximum | 1600 |
| Zeros | 10 |
| Zeros (%) | < 0.1% |
| Memory size | 590.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 110 |
| Q1 | 250 |
| median | 350 |
| Q3 | 510 |
| 95-th percentile | 1150 |
| Maximum | 1600 |
| Range | 1600 |
| Interquartile range (IQR) | 260 |
Descriptive statistics
| Standard deviation | 316.9864231 |
|---|---|
| Coefficient of variation (CV) | 0.7238533631 |
| Kurtosis | 3.251742571 |
| Mean | 437.9152453 |
| Median Absolute Deviation (MAD) | 120 |
| Skewness | 1.848236067 |
| Sum | 33119530 |
| Variance | 100480.3924 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=38)
| Value | Count | Frequency (%) | |
| 350 | 7800 | 10.3% | |
| 360 | 4322 | 5.7% | |
| 220 | 3617 | 4.8% | |
| 320 | 3360 | 4.4% | |
| 550 | 3348 | 4.4% | |
| 530 | 3116 | 4.1% | |
| 110 | 3029 | 4.0% | |
| 90 | 3017 | 4.0% | |
| 510 | 2859 | 3.8% | |
| 380 | 2840 | 3.8% | |
| Other values (28) | 38322 | 50.7% |
| Value | Count | Frequency (%) | |
| 0 | 10 | < 0.1% | |
| 90 | 3017 | 4.0% | |
| 110 | 3029 | 4.0% | |
| 120 | 1293 | 1.7% | |
| 140 | 1200 | 1.6% |
| Value | Count | Frequency (%) | |
| 1600 | 773 | 1.0% | |
| 1550 | 719 | 1.0% | |
| 1500 | 765 | 1.0% | |
| 1150 | 1810 | 2.4% | |
| 1100 | 1679 | 2.2% |
| Distinct | 464 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4631.44916 |
|---|---|
| Minimum | 0 |
| Maximum | 40500 |
| Zeros | 10 |
| Zeros (%) | < 0.1% |
| Memory size | 590.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 460 |
| Q1 | 1650 |
| median | 3520 |
| Q3 | 5850 |
| 95-th percentile | 13800 |
| Maximum | 40500 |
| Range | 40500 |
| Interquartile range (IQR) | 4200 |
Descriptive statistics
| Standard deviation | 4578.533457 |
|---|---|
| Coefficient of variation (CV) | 0.9885746984 |
| Kurtosis | 8.392388159 |
| Mean | 4631.44916 |
| Median Absolute Deviation (MAD) | 2080 |
| Skewness | 2.544365951 |
| Sum | 350276500 |
| Variance | 20962968.61 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 1800 | 1047 | 1.4% | |
| 4200 | 956 | 1.3% | |
| 3300 | 920 | 1.2% | |
| 5600 | 849 | 1.1% | |
| 6300 | 825 | 1.1% | |
| 4800 | 754 | 1.0% | |
| 2100 | 749 | 1.0% | |
| 1440 | 745 | 1.0% | |
| 5760 | 649 | 0.9% | |
| 3960 | 645 | 0.9% | |
| Other values (454) | 67491 | 89.2% |
| Value | Count | Frequency (%) | |
| 0 | 10 | < 0.1% | |
| 90 | 211 | 0.3% | |
| 110 | 129 | 0.2% | |
| 120 | 56 | 0.1% | |
| 140 | 87 | 0.1% |
| Value | Count | Frequency (%) | |
| 40500 | 1 | < 0.1% | |
| 32000 | 100 | 0.1% | |
| 31000 | 32 | < 0.1% | |
| 30400 | 5 | < 0.1% | |
| 30000 | 113 | 0.1% |
Delivery_Cost
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 590.9 KiB |
| 100 | |
|---|---|
| 120 |
| Value | Count | Frequency (%) | |
| 100 | 44779 | 59.2% | |
| 120 | 30851 | 40.8% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
| Distinct | 751 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4739.607563 |
|---|---|
| Minimum | 100 |
| Maximum | 40600 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 590.9 KiB |
Quantile statistics
| Minimum | 100 |
|---|---|
| 5-th percentile | 570 |
| Q1 | 1750 |
| median | 3640 |
| Q3 | 5950 |
| 95-th percentile | 13920 |
| Maximum | 40600 |
| Range | 40500 |
| Interquartile range (IQR) | 4200 |
Descriptive statistics
| Standard deviation | 4578.239994 |
|---|---|
| Coefficient of variation (CV) | 0.9659533902 |
| Kurtosis | 8.388573722 |
| Mean | 4739.607563 |
| Median Absolute Deviation (MAD) | 2060 |
| Skewness | 2.543840906 |
| Sum | 358456520 |
| Variance | 20960281.44 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 1900 | 731 | 1.0% | |
| 4300 | 637 | 0.8% | |
| 3400 | 522 | 0.7% | |
| 1540 | 512 | 0.7% | |
| 1200 | 505 | 0.7% | |
| 820 | 504 | 0.7% | |
| 2200 | 444 | 0.6% | |
| 6400 | 443 | 0.6% | |
| 760 | 440 | 0.6% | |
| 4320 | 432 | 0.6% | |
| Other values (741) | 70460 | 93.2% |
| Value | Count | Frequency (%) | |
| 100 | 6 | < 0.1% | |
| 120 | 4 | < 0.1% | |
| 190 | 126 | 0.2% | |
| 210 | 153 | 0.2% | |
| 220 | 53 | 0.1% |
| Value | Count | Frequency (%) | |
| 40600 | 1 | < 0.1% | |
| 32120 | 10 | < 0.1% | |
| 32100 | 90 | 0.1% | |
| 31120 | 12 | < 0.1% | |
| 31100 | 20 | < 0.1% |
| Distinct | 751 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6161.489832 |
|---|---|
| Minimum | 130 |
| Maximum | 52780 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 590.9 KiB |
Quantile statistics
| Minimum | 130 |
|---|---|
| 5-th percentile | 741 |
| Q1 | 2275 |
| median | 4732 |
| Q3 | 7735 |
| 95-th percentile | 18096 |
| Maximum | 52780 |
| Range | 52650 |
| Interquartile range (IQR) | 5460 |
Descriptive statistics
| Standard deviation | 5951.711992 |
|---|---|
| Coefficient of variation (CV) | 0.9659533902 |
| Kurtosis | 8.388573722 |
| Mean | 6161.489832 |
| Median Absolute Deviation (MAD) | 2678 |
| Skewness | 2.543840906 |
| Sum | 465993476 |
| Variance | 35422875.64 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 2470 | 731 | 1.0% | |
| 5590 | 637 | 0.8% | |
| 4420 | 522 | 0.7% | |
| 2002 | 512 | 0.7% | |
| 1560 | 505 | 0.7% | |
| 1066 | 504 | 0.7% | |
| 2860 | 444 | 0.6% | |
| 8320 | 443 | 0.6% | |
| 988 | 440 | 0.6% | |
| 5616 | 432 | 0.6% | |
| Other values (741) | 70460 | 93.2% |
| Value | Count | Frequency (%) | |
| 130 | 6 | < 0.1% | |
| 156 | 4 | < 0.1% | |
| 247 | 126 | 0.2% | |
| 273 | 153 | 0.2% | |
| 286 | 53 | 0.1% |
| Value | Count | Frequency (%) | |
| 52780 | 1 | < 0.1% | |
| 41756 | 10 | < 0.1% | |
| 41730 | 90 | 0.1% | |
| 40456 | 12 | < 0.1% | |
| 40430 | 20 | < 0.1% |
| Distinct | 702 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 166.8677284 |
|---|---|
| Minimum | 0 |
| Maximum | 2639 |
| Zeros | 36306 |
| Zeros (%) | 48.0% |
| Memory size | 590.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 31.85 |
| Q3 | 256.1 |
| 95-th percentile | 661.05 |
| Maximum | 2639 |
| Range | 2639 |
| Interquartile range (IQR) | 256.1 |
Descriptive statistics
| Standard deviation | 281.9941415 |
|---|---|
| Coefficient of variation (CV) | 1.689926172 |
| Kurtosis | 12.13126442 |
| Mean | 166.8677284 |
| Median Absolute Deviation (MAD) | 31.85 |
| Skewness | 3.052492163 |
| Sum | 12620206.3 |
| Variance | 79520.69583 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 36306 | 48.0% | |
| 123.5 | 462 | 0.6% | |
| 279.5 | 358 | 0.5% | |
| 318.5 | 298 | 0.4% | |
| 310.7 | 287 | 0.4% | |
| 193.7 | 287 | 0.4% | |
| 143 | 285 | 0.4% | |
| 370.5 | 278 | 0.4% | |
| 120.9 | 272 | 0.4% | |
| 235.3 | 261 | 0.3% | |
| Other values (692) | 36536 | 48.3% |
| Value | Count | Frequency (%) | |
| 0 | 36306 | 48.0% | |
| 6.5 | 4 | < 0.1% | |
| 7.8 | 1 | < 0.1% | |
| 12.35 | 124 | 0.2% | |
| 13.65 | 136 | 0.2% |
| Value | Count | Frequency (%) | |
| 2639 | 1 | < 0.1% | |
| 2086.5 | 90 | 0.1% | |
| 2022.8 | 1 | < 0.1% | |
| 2021.5 | 11 | < 0.1% | |
| 1982.5 | 4 | < 0.1% |
| Distinct | 1362 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5994.622104 |
|---|---|
| Minimum | 123.5 |
| Maximum | 50141 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 590.9 KiB |
Quantile statistics
| Minimum | 123.5 |
|---|---|
| 5-th percentile | 728 |
| Q1 | 2262 |
| median | 4680 |
| Q3 | 7582.9 |
| 95-th percentile | 17784 |
| Maximum | 50141 |
| Range | 50017.5 |
| Interquartile range (IQR) | 5320.9 |
Descriptive statistics
| Standard deviation | 5767.503362 |
|---|---|
| Coefficient of variation (CV) | 0.9621129176 |
| Kurtosis | 8.180287113 |
| Mean | 5994.622104 |
| Median Absolute Deviation (MAD) | 2600 |
| Skewness | 2.515167581 |
| Sum | 453373269.7 |
| Variance | 33264095.03 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 2346.5 | 462 | 0.6% | |
| 4446 | 412 | 0.5% | |
| 5310.5 | 358 | 0.5% | |
| 988 | 318 | 0.4% | |
| 1560 | 314 | 0.4% | |
| 6051.5 | 298 | 0.4% | |
| 5161 | 291 | 0.4% | |
| 2002 | 290 | 0.4% | |
| 3680.3 | 287 | 0.4% | |
| 5903.3 | 287 | 0.4% | |
| Other values (1352) | 72313 | 95.6% |
| Value | Count | Frequency (%) | |
| 123.5 | 4 | < 0.1% | |
| 130 | 2 | < 0.1% | |
| 148.2 | 1 | < 0.1% | |
| 156 | 3 | < 0.1% | |
| 234.65 | 124 | 0.2% |
| Value | Count | Frequency (%) | |
| 50141 | 1 | < 0.1% | |
| 41756 | 10 | < 0.1% | |
| 40456 | 11 | < 0.1% | |
| 40430 | 9 | < 0.1% | |
| 39676 | 1 | < 0.1% |
| Distinct | 1362 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1019.085758 |
|---|---|
| Minimum | 20.995 |
| Maximum | 8523.97 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 590.9 KiB |
Quantile statistics
| Minimum | 20.995 |
|---|---|
| 5-th percentile | 123.76 |
| Q1 | 384.54 |
| median | 795.6 |
| Q3 | 1289.093 |
| 95-th percentile | 3023.28 |
| Maximum | 8523.97 |
| Range | 8502.975 |
| Interquartile range (IQR) | 904.553 |
Descriptive statistics
| Standard deviation | 980.4755716 |
|---|---|
| Coefficient of variation (CV) | 0.9621129176 |
| Kurtosis | 8.180287113 |
| Mean | 1019.085758 |
| Median Absolute Deviation (MAD) | 442 |
| Skewness | 2.515167581 |
| Sum | 77073455.85 |
| Variance | 961332.3465 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 398.905 | 462 | 0.6% | |
| 755.82 | 412 | 0.5% | |
| 902.785 | 358 | 0.5% | |
| 167.96 | 318 | 0.4% | |
| 265.2 | 314 | 0.4% | |
| 1028.755 | 298 | 0.4% | |
| 877.37 | 291 | 0.4% | |
| 340.34 | 290 | 0.4% | |
| 625.651 | 287 | 0.4% | |
| 1003.561 | 287 | 0.4% | |
| Other values (1352) | 72313 | 95.6% |
| Value | Count | Frequency (%) | |
| 20.995 | 4 | < 0.1% | |
| 22.1 | 2 | < 0.1% | |
| 25.194 | 1 | < 0.1% | |
| 26.52 | 3 | < 0.1% | |
| 39.8905 | 124 | 0.2% |
| Value | Count | Frequency (%) | |
| 8523.97 | 1 | < 0.1% | |
| 7098.52 | 10 | < 0.1% | |
| 6877.52 | 11 | < 0.1% | |
| 6873.1 | 9 | < 0.1% | |
| 6744.92 | 1 | < 0.1% |
| Distinct | 1362 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7013.707861 |
|---|---|
| Minimum | 144.495 |
| Maximum | 58664.97 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 590.9 KiB |
Quantile statistics
| Minimum | 144.495 |
|---|---|
| 5-th percentile | 851.76 |
| Q1 | 2646.54 |
| median | 5475.6 |
| Q3 | 8871.993 |
| 95-th percentile | 20807.28 |
| Maximum | 58664.97 |
| Range | 58520.475 |
| Interquartile range (IQR) | 6225.453 |
Descriptive statistics
| Standard deviation | 6747.978934 |
|---|---|
| Coefficient of variation (CV) | 0.9621129176 |
| Kurtosis | 8.180287113 |
| Mean | 7013.707861 |
| Median Absolute Deviation (MAD) | 3042 |
| Skewness | 2.515167581 |
| Sum | 530446725.5 |
| Variance | 45535219.69 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 2745.405 | 462 | 0.6% | |
| 5201.82 | 412 | 0.5% | |
| 6213.285 | 358 | 0.5% | |
| 1155.96 | 318 | 0.4% | |
| 1825.2 | 314 | 0.4% | |
| 7080.255 | 298 | 0.4% | |
| 6038.37 | 291 | 0.4% | |
| 2342.34 | 290 | 0.4% | |
| 4305.951 | 287 | 0.4% | |
| 6906.861 | 287 | 0.4% | |
| Other values (1352) | 72313 | 95.6% |
| Value | Count | Frequency (%) | |
| 144.495 | 4 | < 0.1% | |
| 152.1 | 2 | < 0.1% | |
| 173.394 | 1 | < 0.1% | |
| 182.52 | 3 | < 0.1% | |
| 274.5405 | 124 | 0.2% |
| Value | Count | Frequency (%) | |
| 58664.97 | 1 | < 0.1% | |
| 48854.52 | 10 | < 0.1% | |
| 47333.52 | 11 | < 0.1% | |
| 47303.1 | 9 | < 0.1% | |
| 46420.92 | 1 | < 0.1% |
| Distinct | 1376 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1255.014541 |
|---|---|
| Minimum | 23.5 |
| Maximum | 9636 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 590.9 KiB |
Quantile statistics
| Minimum | 23.5 |
|---|---|
| 5-th percentile | 152.75 |
| Q1 | 462 |
| median | 982.3 |
| Q3 | 1586.25 |
| 95-th percentile | 3654.24 |
| Maximum | 9636 |
| Range | 9612.5 |
| Interquartile range (IQR) | 1124.25 |
Descriptive statistics
| Standard deviation | 1203.916507 |
|---|---|
| Coefficient of variation (CV) | 0.9592849075 |
| Kurtosis | 8.032400532 |
| Mean | 1255.014541 |
| Median Absolute Deviation (MAD) | 542.85 |
| Skewness | 2.472160395 |
| Sum | 94916749.7 |
| Variance | 1449414.957 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 446.5 | 462 | 0.6% | |
| 1010.5 | 358 | 0.5% | |
| 360 | 314 | 0.4% | |
| 1151.5 | 298 | 0.4% | |
| 1191 | 291 | 0.4% | |
| 462 | 290 | 0.4% | |
| 700.3 | 287 | 0.4% | |
| 1123.3 | 287 | 0.4% | |
| 517 | 285 | 0.4% | |
| 1290 | 279 | 0.4% | |
| Other values (1366) | 72479 | 95.8% |
| Value | Count | Frequency (%) | |
| 23.5 | 4 | < 0.1% | |
| 28.2 | 1 | < 0.1% | |
| 30 | 2 | < 0.1% | |
| 36 | 3 | < 0.1% | |
| 44.65 | 124 | 0.2% |
| Value | Count | Frequency (%) | |
| 9636 | 10 | < 0.1% | |
| 9541 | 1 | < 0.1% | |
| 9336 | 11 | < 0.1% | |
| 9330 | 9 | < 0.1% | |
| 9156 | 1 | < 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| Item | Date | Quantity | Unit_Cost | Basic_Cost | Delivery_Cost | Net_Cost | Basic_Selling_Price | Discount | Selling_Price | Tax | Cash _Received | Profit | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Soft Drink | 01-Jan-11 | 17 | 110 | 1870 | 120 | 1990 | 2587 | 129.35 | 2457.65 | 417.8005 | 2875.4505 | 467.65 |
| 1 | Hot Wings | 01-Jan-11 | 3 | 390 | 1170 | 120 | 1290 | 1677 | 83.85 | 1593.15 | 270.8355 | 1863.9855 | 303.15 |
| 2 | Pizza Twister | 01-Jan-11 | 8 | 350 | 2800 | 100 | 2900 | 3770 | 0.00 | 3770.00 | 640.9000 | 4410.9000 | 870.00 |
| 3 | Hot Wings | 01-Jan-11 | 2 | 390 | 780 | 120 | 900 | 1170 | 0.00 | 1170.00 | 198.9000 | 1368.9000 | 270.00 |
| 4 | Xtreme Box | 01-Jan-11 | 4 | 1050 | 4200 | 100 | 4300 | 5590 | 0.00 | 5590.00 | 950.3000 | 6540.3000 | 1290.00 |
| 5 | Mid Night Deal | 01-Jan-11 | 17 | 320 | 5440 | 100 | 5540 | 7202 | 360.10 | 6841.90 | 1163.1230 | 8005.0230 | 1301.90 |
| 6 | Hot Wings | 01-Jan-11 | 1 | 390 | 390 | 100 | 490 | 637 | 31.85 | 605.15 | 102.8755 | 708.0255 | 115.15 |
| 7 | Mid Night Deal | 01-Jan-11 | 10 | 320 | 3200 | 100 | 3300 | 4290 | 0.00 | 4290.00 | 729.3000 | 5019.3000 | 990.00 |
| 8 | Bucket of Fries | 01-Jan-11 | 7 | 220 | 1540 | 120 | 1660 | 2158 | 107.90 | 2050.10 | 348.5170 | 2398.6170 | 390.10 |
| 9 | Nuggests | 01-Jan-11 | 9 | 300 | 2700 | 100 | 2800 | 3640 | 0.00 | 3640.00 | 618.8000 | 4258.8000 | 840.00 |
Last rows
| Item | Date | Quantity | Unit_Cost | Basic_Cost | Delivery_Cost | Net_Cost | Basic_Selling_Price | Discount | Selling_Price | Tax | Cash _Received | Profit | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 75620 | Mineral Water | 31-Dec-13 | 14 | 90 | 1260 | 120 | 1380 | 1794 | 89.70 | 1704.30 | 289.7310 | 1994.0310 | 324.30 |
| 75621 | Zinger Combo | 31-Dec-13 | 13 | 510 | 7150 | 100 | 7250 | 9425 | 471.25 | 8953.75 | 1522.1375 | 10475.8875 | 1703.75 |
| 75622 | Hot Wings | 31-Dec-13 | 6 | 390 | 2580 | 100 | 2680 | 3484 | 0.00 | 3484.00 | 592.2800 | 4076.2800 | 804.00 |
| 75623 | Super Spicy Burger | 31-Dec-13 | 18 | 310 | 6300 | 100 | 6400 | 8320 | 416.00 | 7904.00 | 1343.6800 | 9247.6800 | 1504.00 |
| 75624 | Zinger Combo | 31-Dec-13 | 6 | 510 | 3300 | 100 | 3400 | 4420 | 221.00 | 4199.00 | 713.8300 | 4912.8300 | 799.00 |
| 75625 | Mineral Water | 31-Dec-13 | 11 | 90 | 990 | 120 | 1110 | 1443 | 0.00 | 1443.00 | 245.3100 | 1688.3100 | 333.00 |
| 75626 | Bucket of Fries | 31-Dec-13 | 1 | 220 | 250 | 100 | 350 | 455 | 22.75 | 432.25 | 73.4825 | 505.7325 | 82.25 |
| 75627 | Chicky Meal | 31-Dec-13 | 11 | 350 | 4180 | 100 | 4280 | 5564 | 0.00 | 5564.00 | 945.8800 | 6509.8800 | 1284.00 |
| 75628 | Pizza Twister | 31-Dec-13 | 20 | 350 | 7600 | 120 | 7720 | 10036 | 501.80 | 9534.20 | 1620.8140 | 11155.0140 | 1814.20 |
| 75629 | Bucket of Fries | 31-Dec-13 | 18 | 220 | 4500 | 100 | 4600 | 5980 | 0.00 | 5980.00 | 1016.6000 | 6996.6000 | 1380.00 |
Most frequent
| Item | Date | Quantity | Unit_Cost | Basic_Cost | Delivery_Cost | Net_Cost | Basic_Selling_Price | Discount | Selling_Price | Tax | Cash _Received | Profit | count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 160 | Bucket of Fries | 20-Feb-13 | 6 | 250 | 1500 | 100 | 1600 | 2080 | 104.00 | 1976.00 | 335.9200 | 2311.9200 | 376.00 | 3 |
| 171 | Bucket of Fries | 22-Jul-12 | 2 | 230 | 460 | 120 | 580 | 754 | 0.00 | 754.00 | 128.1800 | 882.1800 | 174.00 | 3 |
| 193 | Bucket of Fries | 25-Apr-13 | 20 | 250 | 5000 | 100 | 5100 | 6630 | 331.50 | 6298.50 | 1070.7450 | 7369.2450 | 1198.50 | 3 |
| 612 | Hot Wings | 06-Apr-13 | 16 | 430 | 6880 | 100 | 6980 | 9074 | 0.00 | 9074.00 | 1542.5800 | 10616.5800 | 2094.00 | 3 |
| 733 | Mid Night Deal | 01-Feb-12 | 15 | 350 | 5250 | 100 | 5350 | 6955 | 347.75 | 6607.25 | 1123.2325 | 7730.4825 | 1257.25 | 3 |
| 742 | Mid Night Deal | 01-Sep-13 | 12 | 360 | 4320 | 100 | 4420 | 5746 | 287.30 | 5458.70 | 927.9790 | 6386.6790 | 1038.70 | 3 |
| 845 | Mid Night Deal | 08-Jul-12 | 20 | 350 | 7000 | 100 | 7100 | 9230 | 461.50 | 8768.50 | 1490.6450 | 10259.1450 | 1668.50 | 3 |
| 866 | Mid Night Deal | 10-Aug-12 | 18 | 350 | 6300 | 100 | 6400 | 8320 | 416.00 | 7904.00 | 1343.6800 | 9247.6800 | 1504.00 | 3 |
| 988 | Mid Night Deal | 19-Aug-12 | 18 | 350 | 6300 | 100 | 6400 | 8320 | 416.00 | 7904.00 | 1343.6800 | 9247.6800 | 1504.00 | 3 |
| 1100 | Mid Night Deal | 27-Jun-12 | 17 | 350 | 5950 | 100 | 6050 | 7865 | 393.25 | 7471.75 | 1270.1975 | 8741.9475 | 1421.75 | 3 |